<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Grouping data by page: Page-by </title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
p.whs1 { text-align:center; }
img_whs2 { border:none; width:406px; height:217px; float:none; border-style:none; }
ul.whs3 { list-style:disc; }
p.whs4 { margin-left:0px; }
ol.whs5 { list-style:decimal; }
img_whs6 { border:none; width:13px; height:13px; float:none; border-style:none; }
p.whs7 { margin-left:40px; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs4 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nGrouping data by page: Page-by\nGrouping data by page: Page-by");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Grouping data by page: Page-by</h1>
<p>When you have a very large set of data on a report, it can be easier 
 to work with that data by grouping it into logical subsets, and viewing 
 only one of the subsets at a time. To group data into subsets, you can 
 use the page-by feature. The subsets you separate your business data into 
 are called pages, and you then page your way through the report, one data 
 subset at a time.</p>
<p>For example, the report below shows salary expenditures by Region, Manager, 
 and Employee. You can place Region on the Page-by area and view the salary 
 expenditures data by Manager and Employee, one region at a time. All the 
 data from the report is still present, but it is grouped into smaller, 
 more manageable sections.<br>
&nbsp;</p>
<p align="center" class="whs1"><img src="images/pagebyexample.gif" x-maintain-ratio="TRUE" width="406px" height="217px" border="0" class="img_whs2"></p>
&nbsp; 
<p><span style="margin-left: 0px;">A</span>ttributes and metrics are the 
 most common objects used in the page-by area of a report, although you 
 can enable page-by for most objects that appear on a report. You can page-by 
 any of the following objects:</p>
<ul type="disc" class="whs3">
	
<li class=p><p>Attributes</p></li>
	
<li class=p><p>Metrics</p></li>
	
<li class=p><p>Hierarchies</p></li>
	
<li class=p><p>Consolidations and custom groups. (Consolidations and 
 custom groups are described in the <span style="font-style: italic;"><I>MicroStrategy 
 Advanced Reporting Guide</I></span>.)</p></li>
	
<li class=p><p>Most object prompts. (Specifically, object prompts that 
 are made up of attributes, hierarchies, consolidations, and custom groups. 
 Object prompts containing metrics can be placed in the page-by area as 
 long as the report&rsquo;s rows or columns do not contain a metric. Prompts 
 are discussed in detail in the <span style="font-style: italic;"><I>MicroStrategy 
 Basic Reporting Guide</I></span>)</p></li>
</ul>
<p class="whs4">You can drill on an attribute or compound 
 metric within the Page-by axis. For more information, see 
<a href="Drilling_on_a_grid_report.htm">Drilling 
 on a grid report</a>.</p>
<h2>Prerequisites</h2>
<p>Page-by can be enabled or disabled for your project by your project 
 designer.</p>
<h2>To move an object to the Page-by area</h2>
<p>You can place more than one object in the page-by area. If you decide 
 to place multiple related attributes in the page-by area, be aware that 
 order matters. Whatever you page-by first (furthest to the left) affects 
 the elements displayed in the other page-by fields. Place multiple objects 
 into the page-by area in logical order, from left to right.<br>
&nbsp;</p>
<ol type="1" class="whs5">
	
<li class=p><p>Click the name of a report to execute it.</p></li>
	
<li class=p><p>To show the Page-by area, from the <span style="font-weight: bold;"><B>Tools</B></span> 
 menu, select <span style="font-weight: bold;"><B>Page-by Axis</B></span><span 
 style="margin-left: 40px;">. </span></p></li>
</ol>
<ul><ul type="disc" class="whs3">
		
<li class=p><p>If DHTML is disabled, click the <span style="font-weight: bold;"><B>Go</B></span> 
 icon <img src="images/Go_icon.gif" x-maintain-ratio="TRUE" width="13px" height="13px" border="0" class="img_whs6">.</p></li>
	</ul>
</ul>
<ol start="3" type="1" class="whs5">
	
<li class=p><p>Right-click the object's header in the report, select 
 <span style="font-weight: bold;"><B>Move</B></span>, and then select <span style="font-weight: bold;"><B>To 
 Page-by Axis</B></span>.</p></li>
</ol>
<ul type="disc" class="whs3">
	
<li class=p><p class="whs7">To move metrics to the page-by 
 area, right-click the word Metric on the report and select Page-by. All 
 metrics must be moved together. You cannot have one metric in the page-by 
 area and one on the report grid.</p></li>
</ul>
<ol start="4" type="1" class="whs5">
	
<li class=p><p>The report is automatically re-displayed to show only 
 the subset of data reflecting the current page-by field. Select an option 
 from the page-by field's drop-down list to change the subset of data displayed.</p></li>
	
<li class=p><p>You can reposition the objects in the Page-by area. 
 Right-click the object on the Page-by area, select <span style="font-weight: bold;"><B>Move</B></span>, 
 and then select <span style="font-weight: bold;"><B>To Columns</B></span> or<span 
 style="font-weight: bold;"><B> To Rows</B></span>, as necessary.</p></li>
</ol>
<h3>Related topic</h3>
<ul type="disc" class="whs3">
	
<li class=p><p>
<a HREF="Remove_objects_from_Pageby.htm">Removing objects 
 from the Page-by area</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
